Welcome to pandas!

2.15 表格数据的修改

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

print (df)

返回：

1、单值修改

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.loc[ 1, "数量" ]= 500

print (df)

返回：

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.iloc[ 1,2 ]= 500

print (df)

返回：

2、行修改

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.loc[ 1 ]=[ "冬瓜", 1.2,300 ]

print (df)

返回：

2、列修改

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df[ "数量" ]=[ 10,20,30,40 ]

print (df)

返回：

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.数量=[ 10,20,30,40 ]

print (df)

返回：

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.loc[:, "数量" ]=[ 10,20,30,40 ]

print (df)

返回：

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.iloc[:, 2] ]=[ 10,20,30,56]

print (df)

返回：

3、区域修改

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.loc[[ 1,3 ],[ "产品","数量" ]]=[[ "a", 100 ],[ "b", 200 ]]

print (df)

返回：

import pandas as pd

path = r "D:\Pyobject2023\object\测试\测试素材3.xlsx"

df = pd.read_excel(path)

df.iloc[[ 1,3 ],[ 0,2 ]]=[[ "a", 100 ],[ "b", 200 ]]

print (df)

返回：